A: To sort on multiple selected columns hold SHIFT down while clicking column headers to set multiple sorted columns; hold CTRL down and click columns area to remove sorting.
Q: What expressions can be used to filter data id grid?
A: Now for every column you may specify filter statement which is of the form:
[RELATIONAL SIGN] STATEMENT
where relational sign is one of the following =, <>, <, >, <=, >=.
Omitting relational sign has the same effect as using equal sign ('=').
Statement is any alphanumerical text which is of a valid data type allowed for the corresponding field. For fields which accept string values you may specify filter mask in the statement substituting masked characters with an asterisk or percent ('*' or '%') symbol. To substitute a single character use underscore ('_') mask symbol.
Q: Sometimes specyfying alias or (table name) and dot I should get Completion Proposal with list of table columns. But instead I get a list of tables.
A: That happens when sql parser can't manage with query (it can be not correct, not finished etc.) In that situation parser doesn't know what tables are used in query. So Completion Proposa; doesn't show list of columns but list tables instead.
Q: When I'm in Connect dialog and choose Oracle I got an error "TNS ....". My Oracle configuration is correct because I can connect to server using SQL Plus.
A: It is because you haven't specified proper path to Oracle directory or you have preinstalled Oracle in other directory. dbDeveloper was asking about that path when you run it for the first time. You can set this Oracle home directory path manually in registy key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOME.
Q: I connect through ODBC. During calling some queries I got an error: "Invalid descriptor index <13>"
A: Some ODBC driver can't execute a query, when BLOB column is not the last column for the query. You need to place BLOB columns at the end of select-item list.
Q: What are minimum required files for connect to MS SQL Server?
A: Below you can view description for the files, which are required for connectivity to Microsoft SQL Server. You can place the required files in Windows system directory (WinNT\system32 or Win95\system) or any other, which is necessary to add to the PATH environment variable.
File Name Description
ntwdblib.dll DB-Lib interface library contains functions for the WIN32 API
Communication DLL You can use one of the following Net library:
/ Net Library One library Dbnmpntw.dll - Named Pipes library
for used communication protocol. Dbmssocn.dll or dbnetlib.dll (for MSSQL 2000) - TCP/IP Sockets library
Dbmsspxn.dll - NWLink IPX/SPX library
Dbmsrpcn.dll - Multi-Protocol library
If you will use Named Pipes protocol, then it is enough to distribute the following files with your application: Ntwdblib.dll and Dbnmpntw.dll. As since Named Pipes is default Net-Library for MS SQL Client, if Net-Library entry is not exist in registry.
When you need to use other Net Library (except Named Pipes), then you need to import the following data(Net Library entry) in the system registry for connect through TCP/IP library (for example):
Q: How I can connect to SQL Anywhere(or Adaptive Server Anywhere)?
A: First, you need to run SQL Anywhere as Open Server. ItÆs required Open Server Gateway for SQL Anywhere ver.5 and nothing for SQL Anywhere ver.6 (see SQL Anywhere Manuals for command line options).
Second, you need to install Open Client Library (see below).
A: For deploying Open Client libraries you need to copy the following files and directories from full installation:
File/Directory Name Description
\sybase\dll Includes API-interface and communication libraries.
Libcomn.dll Open Client and Open Server Common Library
Libcs.dll Open Server Library
Libct.dll Open Client Library
Libintl.dll Locale library
Libtcl.dll TLI library
Nlmsnmp.dll Named Pipes Driver
Nlwnsck.dll WinSock TCP/IP Driver
Nlnwlink.dll NWLink IPX/SPX Driver
You can use and deploy only one network driver.
\sybase\ini Contains initialization files
Libtcl.cfg
Objectid.dat
Sql.ini
\sybase\charsets Contains all charsets. You can use and copy only required charsets. In most cases, it is enough ôIso_1ö and ôUtf8ö charset directories.
\sybase\locales Contains messages for some code pages. In most cases, it is enough a ôEnglish\Iso_1ö locale directory.
Also you need set SYBASE environment variable to a path, which contains Sybase client, and add drive:\sybase\dll directory to the PATH environment variable. You can add the following line in your autoexec.bat and change X:\ on your valid driver, which contains Sybase client.
SET SYBASE=X:\sybase
SET PATH=%PATH%;X:\sybase\dll
Below you can see a content of Sql.ini for TCP/IP connect, where ASESRV is a SQL Server name, and SRVHOST(port: 5000) is a host with SQL Server.
Q: How can I connect to specified serwer. What connection string should I put in "Server name" field?
A:
- DB2, Informix and ODBC:
The "Server name" field can contain DSN, which is set up in ODBC Administrator, or a full datasource string with supported parameters for the required server.
Below you can see an example of datasource string for Informix server: